/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.statistics.store;

import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import oracle.jdbc.OracleTypes;
import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.net.entitybean.RP100;
import queenb.web.sms.store.M300Store;
import queenb.web.util.PackageContants;

/**
 *
 * @author HP
 */
public class RP100Store extends RP100{
     public List<RP100> getRP100N100R1(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R1, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R2(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R2, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R3(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R3, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R4(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R4, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R5(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R5, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R6(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R6, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R7(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R7, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100N100R8(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R8, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
        public List<RP100> getRP100N100R9(int pnFH000,int pnFH200,int pnday, String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_N100R9, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                            new Param(OracleTypes.INTEGER, pnday),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      
      
      ///KKKKKKKK
       public List<RP100> getRP100K100R1(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R1, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100K100R2(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R2, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100K100R3(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R3, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100K100R4(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R4, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100K100R5(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R5, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
        public List<RP100> getRP100K100R6(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R6, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
      public List<RP100> getRP100K100R7(int pnFH000,int pnFH200,String pvLOGIN) throws InstantiationException, IllegalAccessException {
        try {
            DataStatement dateStatement = new DataStatement(PackageContants.RP_K100R7, OracleTypes.INTEGER, new Param[]{
                        new Param(OracleTypes.CHAR, pnFH000),
                        new Param(OracleTypes.CHAR, pnFH200),
                        new Param(OracleTypes.CHAR, pvLOGIN),
                       
                       });
            return super.find(dateStatement, RP100.class);
        } catch (SQLException ex) {
            Logger.getLogger(M300Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }
}
